package com.his.his_system.mapper;

import com.his.his_system.domain.DzmHisCareRefundlog;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 覃圣礼
* @description 针对表【dzm_his_care_refundlog(退款记录)】的数据库操作Mapper
* @createDate 2023-07-07 09:13:47
* @Entity com.his.his_system.domain.DzmHisCareRefundlog
*/
public interface DzmHisCareRefundlogMapper extends BaseMapper<DzmHisCareRefundlog> {

      @Select("SELECT * FROM  dzm_his_care_refundlog")
      List<DzmHisCareRefundlog> getReturnPremium();


      /**
       * 退费总额
       */
      @Select("SELECT SUM(refund_amount) FROM dzm_his_care_refundlog")
      String totalRefund();

}




